﻿create table dbo.FunctionsInfo (
   FunctionId           nvarchar(10)         collate Chinese_PRC_CI_AS not null,
   ParentFunctionId     nvarchar(10)         collate Chinese_PRC_CI_AS null,
   FunctionOrder        int                  null,
   FunctionDescription  nvarchar(150)        collate Chinese_PRC_CI_AS null,
   FunctionName         nvarchar(50)         collate Chinese_PRC_CI_AS null,
   URL                  nvarchar(150)        collate Chinese_PRC_CI_AS null,
   IsShow               bit                  null constraint DF_FunctionsInfo_IsShow default 'true',
   IsEnable             bit                  null constraint DF_FunctionsInfo_IsEnable default 'true',
   CreateBy             nvarchar(10)         collate Chinese_PRC_CI_AS null,
   CreateOn             datetime             null constraint DF_FunctionsInfo_CreateOn default getdate(),
   ModifyBy             nvarchar(10)         collate Chinese_PRC_CI_AS null,
   ModifyOn             datetime             null,
   constraint PK_FunctionsInfo primary key (FunctionId)
         on "PRIMARY"
)
on "PRIMARY"
go

execute sp_addextendedproperty 'MS_Description', 
   '功能ID',
   'user', 'dbo', 'table', 'FunctionsInfo', 'column', 'FunctionId'
go

execute sp_addextendedproperty 'MS_Description', 
   '功能上级ID',
   'user', 'dbo', 'table', 'FunctionsInfo', 'column', 'ParentFunctionId'
go

execute sp_addextendedproperty 'MS_Description', 
   '顺序',
   'user', 'dbo', 'table', 'FunctionsInfo', 'column', 'FunctionOrder'
go

execute sp_addextendedproperty 'MS_Description', 
   '描述',
   'user', 'dbo', 'table', 'FunctionsInfo', 'column', 'FunctionDescription'
go

execute sp_addextendedproperty 'MS_Description', 
   '名称',
   'user', 'dbo', 'table', 'FunctionsInfo', 'column', 'FunctionName'
go

execute sp_addextendedproperty 'MS_Description', 
   'URL',
   'user', 'dbo', 'table', 'FunctionsInfo', 'column', 'URL'
go

execute sp_addextendedproperty 'MS_Description', 
   '是否可见（默认True）',
   'user', 'dbo', 'table', 'FunctionsInfo', 'column', 'IsShow'
go

execute sp_addextendedproperty 'MS_Description', 
   '是否启用',
   'user', 'dbo', 'table', 'FunctionsInfo', 'column', 'IsEnable'
go

execute sp_addextendedproperty 'MS_Description', 
   '创建人',
   'user', 'dbo', 'table', 'FunctionsInfo', 'column', 'CreateBy'
go

execute sp_addextendedproperty 'MS_Description', 
   '创建时间',
   'user', 'dbo', 'table', 'FunctionsInfo', 'column', 'CreateOn'
go

execute sp_addextendedproperty 'MS_Description', 
   '更改人',
   'user', 'dbo', 'table', 'FunctionsInfo', 'column', 'ModifyBy'
go

execute sp_addextendedproperty 'MS_Description', 
   '更改时间',
   'user', 'dbo', 'table', 'FunctionsInfo', 'column', 'ModifyOn'
go

